package com.ktjiaoyu.crm.mapper;
import com.ktjiaoyu.crm.pojo.User;
import org.apache.ibatis.annotations.*;
import java.util.List;
public interface UserMapper {
    @Insert("INSERT INTO sys_user(usr_name,usr_password,usr_role_id,usr_flag) "+"values(#usrName,#usrPassword,#usrRoleId,#usrFlag)")
    public void insert(User user);
    @Delete("delete from sys_user where usr_id = #{id}")
    public void delete(Long id);
    @Update("<script>" +
            "update sys_user " +
            "<set>" +
            "<if test='usrName != null'>usr_name = #{usrName},</if>" +
            "<if test='usrPassword != null'>usr_password = #{usrPassword},</if>" +
            "<if test='usrRoleId != null'>usr_role_id = #{usrRoleId},</if>" +
            "<if test='usrFlag != null'>usr_flag = #{usrFlag},</if>" +
            "</set>" +
            "where usr_id = #{usrId}" +
            "</script>")
    public void update(User user);
    @Select("SELECT usr_id,usr_name,usr_password,usr_role_id,usr_flag "+" FROM sys_user where usr_id = #{id} ")
    @Results({
            @Result(id = true,column = "usr_id",property = "usrId"),
            @Result(column = "usr_name",property = "usrName"),
            @Result(column = "usr_password",property = "usrPassword"),
            @Result(column = "usr_role_id",property = "usrRoleId"),
            @Result(column = "usr_flag",property = "usrFlag")
    })
    public User get(Long id);
    @Select("SELECT usr_id,usr_name,usr_password,usr_role_id,usr_flag FROM sys_user ")
    @Results({
            @Result(id = true,column = "usr_id",property = "usrId"),
            @Result(column = "usr_name",property = "usrName"),
            @Result(column = "usr_password",property = "usrPassword"),
            @Result(column = "usr_role_id",property = "usrRoleId"),
            @Result(column = "usr_flag",property = "usrFlag")
    })
    public List<User> findAll();
}
